﻿# MySQL-Front 5.1  (Build 3.18)

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE */;
/*!40101 SET SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES */;
/*!40103 SET SQL_NOTES='ON' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS */;
/*!40014 SET FOREIGN_KEY_CHECKS=0 */;


# Host: localhost    Database: openshop
# ------------------------------------------------------
# Server version 5.1.35-community

#
# Source for table open_purchase_balance_pay
#

DROP TABLE IF EXISTS `open_purchase_balance_pay`;
CREATE TABLE `open_purchase_balance_pay` (
  `balance_pay_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `balance_order_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `pay_type` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `pay_amount` decimal(10,2) unsigned NOT NULL DEFAULT '0.00',
  `pay_date` int(10) unsigned NOT NULL DEFAULT '0',
  `trade_off_sn` varchar(255) NOT NULL DEFAULT '',
  `trade_off_date` int(10) unsigned NOT NULL DEFAULT '0',
  `pay_accounts` varchar(255) NOT NULL DEFAULT '',
  `pay_brief` tinytext NOT NULL,
  PRIMARY KEY (`balance_pay_id`),
  KEY `balance_order_id` (`balance_order_id`),
  KEY `pay_type` (`pay_type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

#
# Dumping data for table open_purchase_balance_pay
#
LOCK TABLES `open_purchase_balance_pay` WRITE;
/*!40000 ALTER TABLE `open_purchase_balance_pay` DISABLE KEYS */;

/*!40000 ALTER TABLE `open_purchase_balance_pay` ENABLE KEYS */;
UNLOCK TABLES;

/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
